<report xmlns="http://developer.cognos.com/schemas/report/11.0/" useStyleVersion="10" expressionLocale="en-us">
				<modelPath>/content/folder[@name='Packages']/package[@name='Inventory']/model[@name='model']</modelPath>
				<drillBehavior/>
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1">
								<style>
									<defaultStyles>
										<defaultStyle refStyle="pg"/>
									</defaultStyles>
								<CSS value="width:1500px"/></style>
								<pageBody>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pb"/>
										</defaultStyles>
									</style>
									<contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Weekly Compute Consumption</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Hypervisor Count</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton refQuery="Capacity Changes" name="Singleton1">
			<contents><textItem><dataSource><dataItemValue refDataItem="Hypervisor Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><singleton refQuery="Capacity Changes" name="Singleton7">
			<contents><textItem><dataSource><dataItemValue refDataItem="ESX Change"/></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-style:italic;color:#808080"/><dataFormat><percentFormat decimalSize="2"/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 1"/></conditionalStyleRefs></textItem></contents>
		</singleton><textItem><dataSource><staticValue>from Last Week</staticValue></dataSource><style><CSS value="padding-left:5px"/></style></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#808080"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Virtual Machine Count</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton refQuery="Capacity Changes" name="Singleton2">
			<contents><textItem><dataSource><dataItemValue refDataItem="VM Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><singleton refQuery="Capacity Changes" name="Singleton8">
			<contents><textItem><dataSource><dataItemValue refDataItem="VM Change"/></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-style:italic;color:#808080"/><dataFormat><percentFormat decimalSize="2"/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 2"/></conditionalStyleRefs></textItem></contents>
		</singleton><textItem><dataSource><staticValue>from Last Week</staticValue></dataSource><style><CSS value="padding-left:5px"/></style></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#808080"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Datastore Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton refQuery="Capacity Changes" name="Singleton3">
			<contents><textItem><dataSource><dataItemValue refDataItem="Datastore Allocated (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><singleton refQuery="Capacity Changes" name="Singleton9">
			<contents><textItem><dataSource><dataItemValue refDataItem="Datastore Allocated Change"/></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-style:italic;color:#808080"/><dataFormat><percentFormat decimalSize="2"/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 3"/></conditionalStyleRefs></textItem></contents>
		</singleton><textItem><dataSource><staticValue>from Last Week</staticValue></dataSource><style><CSS value="padding-left:5px"/></style></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#808080"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total VMDK Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton refQuery="Capacity Changes" name="Singleton4">
			<contents><textItem><dataSource><dataItemValue refDataItem="VMDK Allocated (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><singleton refQuery="Capacity Changes" name="Singleton10">
			<contents><textItem><dataSource><dataItemValue refDataItem="VMDK Allocated Change"/></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-style:italic;color:#808080"/><dataFormat><percentFormat decimalSize="2"/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 4"/></conditionalStyleRefs></textItem></contents>
		</singleton><textItem><dataSource><staticValue>from Last Week</staticValue></dataSource><style><CSS value="padding-left:5px"/></style></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#808080"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Used Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton refQuery="Capacity Changes" name="Singleton5">
			<contents><textItem><dataSource><dataItemValue refDataItem="Used (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><singleton refQuery="Capacity Changes" name="Singleton11">
			<contents><textItem><dataSource><dataItemValue refDataItem="Used Change"/></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-style:italic;color:#808080"/><dataFormat><percentFormat decimalSize="2"/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 5"/></conditionalStyleRefs></textItem></contents>
		</singleton><textItem><dataSource><staticValue>from Last Week</staticValue></dataSource><style><CSS value="padding-left:5px"/></style></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#808080"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Free Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton refQuery="Capacity Changes" name="Singleton6">
			<contents><textItem><dataSource><dataItemValue refDataItem="Free (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><singleton refQuery="Capacity Changes" name="Singleton12">
			<contents><textItem><dataSource><dataItemValue refDataItem="Free Change"/></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-style:italic;color:#808080"/><dataFormat><percentFormat decimalSize="2"/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 6"/></conditionalStyleRefs></textItem></contents>
		</singleton><textItem><dataSource><staticValue>from Last Week</staticValue></dataSource><style><CSS value="padding-left:5px"/></style></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#808080"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Workload Activity Trends</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Weekly Trends over Last 90 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents/><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart1" refQuery="Workload Activities">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="(MM/dd)"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineDisplayType="lineAndMarkers" lineAreaShape="smooth"><v2_linePalette markerBorders="show" markerSize="8px" markerBorderColor="white"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor transparency="30" color="#1ABB9C"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#1ABB9C"/></v2_lineFill></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Peak CPU Utilization"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Peak Memory Utilization"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line></v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							
																						<v2_specifiedRange max="1"/></v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:1480px;height:200px"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style>
																				</v2_legend>
																				<XMLAttributes><XMLAttribute name="titlesExpanded" value="true" output="no"/></XMLAttributes></v2_combinationChart>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Clusters by Capacity Usage</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="width:5px;background-color:white"/></style></tableCell><tableCell><contents/><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell><tableCell><contents>
																		<list horizontalPagination="true" name="List1" refQuery="Top Clusters by Capacity Usage">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Cluster"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#808080;text-align:left;padding-left:5px;padding-top:5px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Cluster"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#808080;text-align:right;padding-top:5px"/><dataFormat><numberFormat pattern="###,###,### TB"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Used (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><staticValue>Combination Chart</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="text-align:center"/></style><contents><v2_combinationChart maxHotspots="10000" orientation="horizontal" name="Combination Chart2" refQuery="Top Clusters by Capacity Usage">
																															<v2_combinationTypeTooltips/>
																															<v2_commonAxis>
																																<v2_ordinalAxis/>
																															</v2_commonAxis>
																															<v2_topLeftAxis>
																																<v2_combinationChartTypes>
																																	<v2_bar seriesType="stacked" borders="show" borderColor="white">
																																		<v2_solidPalette>
																																			<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#8599D3"><v2_solidColor transparency="30" color="#1ABB9C"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C7C7C7"><v2_solidColor color="#C7C7C7" transparency="50"/></v2_fillEffect></v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																																		<!-- v2_solidPaletteRef ref=&amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;quot;/ -->
																																		<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Free (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																</v2_combinationChartTypes>
																																<v2_axis>
																																	<v2_axisRange>
																																		<v2_automaticRange/>
																																	</v2_axisRange>
																																</v2_axis>
																															</v2_topLeftAxis>
																															<style>
																																<defaultStyles>
																																	<defaultStyle refStyle="ch"/>
																																</defaultStyles>
																																<CSS value="padding:0px;width:200px;height:20px"/>
																															</style>
																															<noDataHandler>
																																<contents>
																																	<block>
																																		<contents>
																																			<textItem>
																																				<dataSource>
																																					<staticValue>No Data Available</staticValue>
																																				</dataSource>
																																				<style>
																																					<CSS value="padding:10px 18px;"/>
																																				</style>
																																			</textItem>
																																		</contents>
																																	</block>
																																</contents>
																															</noDataHandler>
																															<XMLAttributes>
																																<XMLAttribute name="beganAsMicroChart" value="true" output="no"/>
																															</XMLAttributes>
																															<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Cluster"/></masterContext><detailContext><dataItemContext refDataItem="Cluster"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart>
																													</contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Allocated (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#808080;text-align:right;padding-right:5px;padding-top:5px"/><dataFormat><numberFormat pattern="###,###,### TB"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="Used (TB)" sortOrder="descending"/></sortList></list></contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Clusters by CPU Usage</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Peak Usage from Last 7 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="width:5px;background-color:white"/></style></tableCell><tableCell><contents/><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="width:5px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell><tableCell><contents>
																		<list horizontalPagination="true" name="List2" refQuery="Top Clusters  by Node Usage">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Cluster"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#808080;text-align:left;padding-left:5px;padding-top:5px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Cluster"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><staticValue>Combination Chart</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles></style><contents><v2_combinationChart maxHotspots="10000" orientation="horizontal" name="Combination Chart3" refQuery="Top Clusters  by Node Usage">
																															<v2_combinationTypeTooltips/>
																															<v2_commonAxis>
																																<v2_ordinalAxis/>
																															</v2_commonAxis>
																															<v2_topLeftAxis>
																																<v2_combinationChartTypes>
																																	<v2_bar seriesType="stacked" borders="show" borderColor="white">
																																		<v2_solidPalette>
																																			<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#8599D3"><v2_solidColor transparency="30" color="#1ABB9C"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C7C7C7"><v2_solidColor color="#C7C7C7" transparency="50"/></v2_fillEffect></v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																																		<!-- v2_solidPaletteRef ref=&amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;quot;/ -->
																																		<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Peak CPU Utilization"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Available"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																</v2_combinationChartTypes>
																																<v2_axis>
																																	<v2_axisRange>
																																		
																																	<v2_specifiedRange max="1"/></v2_axisRange>
																																</v2_axis>
																															</v2_topLeftAxis>
																															<style>
																																<defaultStyles>
																																	<defaultStyle refStyle="ch"/>
																																</defaultStyles>
																																<CSS value="padding:0px;width:200px;height:20px"/>
																															</style>
																															<noDataHandler>
																																<contents>
																																	<block>
																																		<contents>
																																			<textItem>
																																				<dataSource>
																																					<staticValue>No Data Available</staticValue>
																																				</dataSource>
																																				<style>
																																					<CSS value="padding:10px 18px;"/>
																																				</style>
																																			</textItem>
																																		</contents>
																																	</block>
																																</contents>
																															</noDataHandler>
																															<XMLAttributes>
																																<XMLAttribute name="beganAsMicroChart" value="true" output="no"/>
																															</XMLAttributes>
																															<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Cluster"/></masterContext><detailContext><dataItemContext refDataItem="Cluster"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart>
																													</contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#808080;text-align:right;padding-right:5px;padding-top:5px"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak CPU Utilization"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="Peak CPU Utilization" sortOrder="descending"/></sortList></list></contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-right:5px;padding-left:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Clusters by Memory Usage</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Peak Usage from Last 7 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents/><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="width:5px;background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		<list horizontalPagination="true" name="List3" refQuery="Top Clusters by Disk Usage">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Cluster"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#808080;text-align:left;padding-left:5px;padding-top:5px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Cluster"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><staticValue>Combination Chart</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles></style><contents><v2_combinationChart maxHotspots="10000" orientation="horizontal" name="Combination Chart4" refQuery="Top Clusters by Disk Usage">
																															<v2_combinationTypeTooltips/>
																															<v2_commonAxis>
																																<v2_ordinalAxis/>
																															</v2_commonAxis>
																															<v2_topLeftAxis>
																																<v2_combinationChartTypes>
																																	<v2_bar seriesType="stacked" borders="show" borderColor="white">
																																		<v2_solidPalette>
																																			<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#8599D3"><v2_solidColor transparency="30" color="#1ABB9C"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C7C7C7"><v2_solidColor color="#C7C7C7" transparency="50"/></v2_fillEffect></v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																																		<!-- v2_solidPaletteRef ref=&amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;quot;/ -->
																																		<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Peak Memory Utilization"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Available"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																</v2_combinationChartTypes>
																																<v2_axis>
																																	<v2_axisRange>
																																		
																																	<v2_specifiedRange max="1"/></v2_axisRange>
																																</v2_axis>
																															</v2_topLeftAxis>
																															<style>
																																<defaultStyles>
																																	<defaultStyle refStyle="ch"/>
																																</defaultStyles>
																																<CSS value="padding:0px;width:200px;height:20px"/>
																															</style>
																															<noDataHandler>
																																<contents>
																																	<block>
																																		<contents>
																																			<textItem>
																																				<dataSource>
																																					<staticValue>No Data Available</staticValue>
																																				</dataSource>
																																				<style>
																																					<CSS value="padding:10px 18px;"/>
																																				</style>
																																			</textItem>
																																		</contents>
																																	</block>
																																</contents>
																															</noDataHandler>
																															<XMLAttributes>
																																<XMLAttribute name="beganAsMicroChart" value="true" output="no"/>
																															</XMLAttributes>
																															<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Cluster"/></masterContext><detailContext><dataItemContext refDataItem="Cluster"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart>
																													</contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents/></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#808080;text-align:right;padding-right:5px;padding-top:5px"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak Memory Utilization"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="Peak Memory Utilization" sortOrder="descending"/></sortList></list></contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white;width:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Capacity by Hypervisor</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Performance Usage from Last 7 Days)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents/><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		<list horizontalPagination="true" name="List4" refQuery="Capacity and Performance by ESX" rowsPerPage="20000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;border-bottom:2px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Cluster"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;padding-top:10px;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Cluster"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;border-bottom:2px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Hypervisor"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;padding-top:10px;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Hypervisor"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;border-bottom:2px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="VM Count"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;padding-top:10px;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="VM Count"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;border-bottom:2px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="CPU Count"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;padding-top:10px;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="CPU Count"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;border-bottom:2px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Memory (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;padding-top:10px;border-bottom:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Memory (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;border-bottom:2px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Average CPU (%)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;padding-top:10px;border-bottom:1px solid #E1E1E2"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Average CPU (%)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;border-bottom:2px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak CPU (%)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;padding-top:10px;border-bottom:1px solid #E1E1E2"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak CPU (%)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;border-bottom:2px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Average Memory (%)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;padding-top:10px;border-bottom:1px solid #E1E1E2"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Average Memory (%)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:left;padding-bottom:5px;font-family:Arial;font-size:12px;color:#808080;border-bottom:2px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak Memory (%)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;font-family:Arial;font-size:12px;color:#808080;padding-top:10px;border-bottom:1px solid #E1E1E2"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak Memory (%)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#808080;text-align:left;border-bottom:2px solid #E1E1E2"/></style><contents><textItem><dataSource><staticValue>Last Week's CPU Trends</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="text-align:center;border-bottom:1px solid #E1E1E2"/></style><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart6" refQuery="Last Week's Performance Trends">
																															<v2_combinationTypeTooltips/>
																															<v2_commonAxis>
																																<v2_ordinalAxis/>
																																<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																															<v2_topLeftAxis>
																																<v2_combinationChartTypes>
																																	<v2_bar>
																																		<v2_solidPalette>
																																			<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#8599D3"><v2_solidColor transparency="30" color="#1ABB9C"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C7C7C7"><v2_solidColor color="#C7C7C7" transparency="50"/></v2_fillEffect></v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																																		<!-- v2_solidPaletteRef ref=&amp;amp;quot;gDefaultSolid&amp;amp;quot;/ -->
																																	</v2_bar>
																																</v2_combinationChartTypes>
																																<v2_axis>
																																	<v2_axisRange>
																																		<v2_automaticRange sameRangeAllInstances="false"/>
																																	</v2_axisRange>
																																</v2_axis>
																															</v2_topLeftAxis>
																															<style>
																																<CSS value="padding:0px;width:125px;height:25px;font-family:Arial;color:#808080"/>
																																<defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																															<noDataHandler>
																																<contents>
																																	<block>
																																		<contents>
																																			<textItem>
																																				<dataSource>
																																					<staticValue>No Data Available</staticValue>
																																				</dataSource>
																																				<style>
																																					<CSS value="padding:10px 18px;"/>
																																				</style>
																																			</textItem>
																																		</contents>
																																	</block>
																																</contents>
																															</noDataHandler>
																															<XMLAttributes>
																																<XMLAttribute name="beganAsMicroChart" value="true" output="no"/>
																															</XMLAttributes>
																															<v2_defaultChartMeasure refDataItem="CPU (%)"><style><dataFormat><percentFormat/></dataFormat></style></v2_defaultChartMeasure><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Cluster"/></masterContext><detailContext><dataItemContext refDataItem="Cluster"/></detailContext></masterDetailLink><masterDetailLink><masterContext><dataItemContext refDataItem="Hypervisor"/></masterContext><detailContext><dataItemContext refDataItem="ESX"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart>
																													</contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#808080;text-align:left;border-bottom:2px solid #E1E1E2"/></style><contents><textItem><dataSource><staticValue>Last Week's Memory Trends</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="text-align:center;border-bottom:1px solid #E1E1E2"/></style><contents><v2_combinationChart maxHotspots="10000" refQuery="Last Week's Performance Trends" name="Combination Chart5">
																															<v2_combinationTypeTooltips/>
																															<v2_commonAxis>
																																<v2_ordinalAxis/>
																																<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																															<v2_topLeftAxis>
																																<v2_combinationChartTypes>
																																	<v2_bar>
																																		<v2_solidPalette>
																																			<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#8599D3"><v2_solidColor transparency="30" color="#1ABB9C"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C7C7C7"><v2_solidColor color="#C7C7C7" transparency="50"/></v2_fillEffect></v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																																		<!-- v2_solidPaletteRef ref=&amp;amp;quot;gDefaultSolid&amp;amp;quot;/ -->
																																	</v2_bar>
																																</v2_combinationChartTypes>
																																<v2_axis>
																																	<v2_axisRange>
																																		<v2_automaticRange sameRangeAllInstances="false"/>
																																	</v2_axisRange>
																																</v2_axis>
																															</v2_topLeftAxis>
																															<style>
																																<CSS value="padding:0px;width:125px;height:25px;font-family:Arial;color:#808080"/>
																																<defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																															<noDataHandler>
																																<contents>
																																	<block>
																																		<contents>
																																			<textItem>
																																				<dataSource>
																																					<staticValue>No Data Available</staticValue>
																																				</dataSource>
																																				<style>
																																					<CSS value="padding:10px 18px;"/>
																																				</style>
																																			</textItem>
																																		</contents>
																																	</block>
																																</contents>
																															</noDataHandler>
																															<XMLAttributes>
																																<XMLAttribute name="beganAsMicroChart" value="true" output="no"/>
																															</XMLAttributes>
																															<v2_defaultChartMeasure refDataItem="Memory (%)"><style><dataFormat><percentFormat/></dataFormat></style></v2_defaultChartMeasure><masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Cluster"/></masterContext><detailContext><dataItemContext refDataItem="Cluster"/></detailContext></masterDetailLink><masterDetailLink><masterContext><dataItemContext refDataItem="Hypervisor"/></masterContext><detailContext><dataItemContext refDataItem="ESX"/></detailContext></masterDetailLink></masterDetailLinks></v2_combinationChart>
																													</contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="text-align:center;padding-top:5px;padding-bottom:5px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7;height:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="true" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/><XMLAttribute name="RS_modelModificationTime" value="2016-01-14T14:24:37.854Z" output="no"/></XMLAttributes><queries><query name="Capacity Changes">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	minDate.fullDate AS 'Previous Month Date',
	maxDate.fullDate AS 'Full Date',
	maxDate.hostTk AS 'Hypervisor Count',
	maxDate.vmTk AS 'VM Count',
	maxDate.dataStoreTB AS 'Datastore Allocated',
	maxDate.vmdkTB AS 'VMDK Allocated (TB)',
	maxDate.usedTB AS 'Used (TB)',
	maxDate.freeTB AS 'Free (TB)',
	ROUND((maxDate.hostTk - minDate.hostTk)/minDate.hostTk, 4) AS 'ESX Change',
	ROUND((maxDate.vmTk - minDate.vmTk)/minDate.vmTk, 4) AS 'VM Change',
	ROUND((maxDate.dataStoreTB - minDate.dataStoreTB)/minDate.dataStoreTB, 4) AS 'Datastore Allocated Change',
	ROUND((maxDate.vmdkTB - minDate.vmdkTB)/minDate.vmdkTB, 4) AS 'VMDK Allocated Change',
	ROUND((maxDate.usedTB - minDate.usedTB)/minDate.usedTB, 4) AS 'Used Change',
	ROUND((maxDate.freeTB - minDate.freeTB)/minDate.freeTB, 4) AS 'Free Change'
FROM 	(
 	SELECT 	dwh_capacity.date_dimension.fullDate AS fullDate,
		COUNT(DISTINCT dwh_capacity.vm_capacity_fact.hostTk) AS hostTk,
		COUNT(DISTINCT dwh_capacity.vm_capacity_fact.vmTk) AS vmTk,
		ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB)/1024/1024, 0) AS dataStoreTB,
		ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024, 0) AS vmdkTB,
		ROUND(SUM(IF(dwh_capacity.vm_capacity_fact.capacityType = 'Datastore Unused', 0, dwh_capacity.vm_capacity_fact.actualMB))/1024/1024, 0) AS usedTB,
		ROUND(SUM(IF(dwh_capacity.vm_capacity_fact.capacityType &lt;&gt; 'Datastore Unused', 0, dwh_capacity.vm_capacity_fact.actualMB))/1024/1024, 0) AS freeTB
	FROM 	dwh_capacity.vm_capacity_fact
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	dwh_capacity.date_dimension.latest = 1
	) maxDate,
	(
 	SELECT 	dwh_capacity.date_dimension.fullDate AS fullDate,
		COUNT(DISTINCT dwh_capacity.vm_capacity_fact.hostTk) AS hostTk,
		COUNT(DISTINCT dwh_capacity.vm_capacity_fact.vmTk) AS vmTk,
		ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB)/1024/1024, 0) AS dataStoreTB,
		ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024, 0) AS vmdkTB,
		ROUND(SUM(IF(dwh_capacity.vm_capacity_fact.capacityType = 'Datastore Unused', 0, dwh_capacity.vm_capacity_fact.actualMB))/1024/1024, 0) AS usedTB,
		ROUND(SUM(IF(dwh_capacity.vm_capacity_fact.capacityType &lt;&gt; 'Datastore Unused', 0, dwh_capacity.vm_capacity_fact.actualMB))/1024/1024, 0) AS freeTB
	FROM 	dwh_capacity.vm_capacity_fact
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	DATE(dwh_capacity.date_dimension.fullDate) = (SELECT DATE(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension WHERE latest = 1) - INTERVAL 7 DAY
        ) minDate</sqlText>
		<mdProjectedItems><mdProjectedItem name="Previous Month Date"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Hypervisor Count"/><mdProjectedItem name="VM Count"/><mdProjectedItem name="Datastore Allocated"/><mdProjectedItem name="VMDK Allocated (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Free (TB)"/><mdProjectedItem name="ESX Change"/><mdProjectedItem name="VM Change"/><mdProjectedItem name="Datastore Allocated Change"/><mdProjectedItem name="VMDK Allocated Change"/><mdProjectedItem name="Used Change"/><mdProjectedItem name="Free Change"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Previous Month Date"><expression>[SQL1].[Previous Month Date]</expression></dataItem><dataItem name="Full Date"><expression>[SQL1].[Full Date]</expression></dataItem><dataItem name="Hypervisor Count"><expression>[SQL1].[Hypervisor Count]</expression></dataItem><dataItem name="VM Count"><expression>[SQL1].[VM Count]</expression></dataItem><dataItem name="Datastore Allocated (TB)"><expression>[SQL1].[Datastore Allocated]</expression></dataItem><dataItem name="VMDK Allocated (TB)"><expression>[SQL1].[VMDK Allocated (TB)]</expression></dataItem><dataItem name="Used (TB)"><expression>[SQL1].[Used (TB)]</expression></dataItem><dataItem name="Free (TB)"><expression>[SQL1].[Free (TB)]</expression></dataItem><dataItem name="ESX Change"><expression>[SQL1].[ESX Change]</expression></dataItem><dataItem name="VM Change"><expression>[SQL1].[VM Change]</expression></dataItem><dataItem name="Datastore Allocated Change"><expression>[SQL1].[Datastore Allocated Change]</expression></dataItem><dataItem name="VMDK Allocated Change"><expression>[SQL1].[VMDK Allocated Change]</expression></dataItem><dataItem name="Used Change"><expression>[SQL1].[Used Change]</expression></dataItem><dataItem name="Free Change"><expression>[SQL1].[Free Change]</expression></dataItem></selection>
		</query><query name="Workload Activities">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 	esxPerf.fullDate AS 'Date',
	ROUND(AVG(esxPerf.cpuUsed), 2) AS 'CPU Utilization - AVG',
	MAX(esxPerf.cpuUsed) AS 'CPU Utilization - MAX',
	ROUND(AVG(esxPerf.memUsed), 2) AS 'Memory Utilization - AVG',
	MAX(esxPerf.memUsed) AS 'Memory Utilization - MAX'
FROM 	(
	SELECT 	dwh_performance.date_dimension.tk dateTk,
		dwh_performance.date_dimension.fullDate fullDate,
		dwh_inventory.hv_server.clusterName cluster,
		dwh_performance.host_dimension.name esx,
		ROUND(MAX(dwh_performance.host_vm_daily_performance_fact.cpuUtilization)/100,2) cpuUsed,
		ROUND(MAX(dwh_performance.host_vm_daily_performance_fact.memoryUtilization)/100,2) memUsed
	FROM 	dwh_performance.host_vm_daily_performance_fact
	JOIN 	dwh_performance.host_dimension
	ON 	dwh_performance.host_vm_daily_performance_fact.hostTk = dwh_performance.host_dimension.tk
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.host_vm_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.repWeek = 1
	AND 	dwh_performance.date_dimension.fullDate &gt;= 	(	SELECT 	MAX(dwh_performance.date_dimension.fullDate)
									FROM 	dwh_performance.date_dimension
									JOIN 	dwh_performance.host_vm_daily_performance_fact
									ON 	dwh_performance.date_dimension.tk = dwh_performance.host_vm_daily_performance_fact.dateTk ) - INTERVAL 90 DAY
	LEFT JOIN
		dwh_inventory.hv_server
	ON 	dwh_performance.host_dimension.id = dwh_inventory.hv_server.hostId
	GROUP BY
		dwh_performance.date_dimension.fullDate,
		dwh_inventory.hv_server.clusterName,
		dwh_performance.host_dimension.name
	) esxPerf
GROUP BY
	esxPerf.fullDate</sqlText>
		<mdProjectedItems><mdProjectedItem name="Date"/><mdProjectedItem name="CPU Utilization - AVG"/><mdProjectedItem name="CPU Utilization - MAX"/><mdProjectedItem name="Memory Utilization - AVG"/><mdProjectedItem name="Memory Utilization - MAX"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Date"><expression>[SQL2].[Date]</expression></dataItem><dataItem name="CPU Utilization - AVG" aggregate="average"><expression>[SQL2].[CPU Utilization - AVG]</expression></dataItem><dataItem name="Peak CPU Utilization" aggregate="maximum"><expression>[SQL2].[CPU Utilization - MAX]</expression></dataItem><dataItem name="Memory Utilization - AVG" aggregate="average"><expression>[SQL2].[Memory Utilization - AVG]</expression></dataItem><dataItem name="Peak Memory Utilization" aggregate="maximum"><expression>[SQL2].[Memory Utilization - MAX]</expression></dataItem></selection>
		</query><query name="Top Clusters by Capacity Usage">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT dwh_inventory.hv_server.clusterName AS 'Cluster',
	ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB)/1024/1024, 0) AS 'Allocated (TB)',
	ROUND(SUM(IF(dwh_capacity.vm_capacity_fact.capacityType = 'Datastore Unused', 0, dwh_capacity.vm_capacity_fact.actualMB))/1024/1024, 0) AS 'Used (TB)',
	ROUND(SUM(IF(dwh_capacity.vm_capacity_fact.capacityType &lt;&gt; 'Datastore Unused', 0, dwh_capacity.vm_capacity_fact.actualMB))/1024/1024, 0) AS 'Free (TB)'
FROM 	dwh_capacity.vm_capacity_fact
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_capacity.date_dimension.latest = 1
JOIN 	dwh_capacity.host_dimension
ON 	dwh_capacity.vm_capacity_fact.hostTk = dwh_capacity.host_dimension.tk
JOIN 	dwh_inventory.hv_server
ON 	dwh_capacity.host_dimension.id = dwh_inventory.hv_server.hostId
GROUP BY
	dwh_inventory.hv_server.clusterName
ORDER BY
	`Used (TB)` DESC
LIMIT 5</sqlText>
		<mdProjectedItems><mdProjectedItem name="Cluster"/><mdProjectedItem name="Allocated (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Free (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Cluster"><expression>[SQL3].[Cluster]</expression></dataItem><dataItem name="Allocated (TB)"><expression>[SQL3].[Allocated (TB)]</expression></dataItem><dataItem name="Used (TB)" aggregate="total"><expression>[SQL3].[Used (TB)]</expression></dataItem><dataItem name="Free (TB)" aggregate="total"><expression>[SQL3].[Free (TB)]</expression></dataItem></selection>
		</query><query name="Top Clusters  by Node Usage">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 	IFNULL(esxPerf.cluster, 'N/A') AS 'Cluster',
	ROUND(AVG(esxPerf.cpuUsed), 2) AS 'CPU Utilization - AVG',
	MAX(esxPerf.cpuUsed) AS 'Peak CPU Utilization',
	ROUND(AVG(esxPerf.memUsed), 2) AS 'Memory Utilization - AVG',
	MAX(esxPerf.memUsed) AS 'Peak Memory Utilization'
FROM 	(
	SELECT 	dwh_performance.date_dimension.tk dateTk,
		dwh_performance.date_dimension.fullDate fullDate,
		dwh_inventory.hv_server.clusterName cluster,
		dwh_performance.host_dimension.name esx,
		ROUND(MAX(dwh_performance.host_vm_daily_performance_fact.cpuUtilization)/100,2) cpuUsed,
		ROUND(MAX(dwh_performance.host_vm_daily_performance_fact.memoryUtilization)/100,2) memUsed
	FROM 	dwh_performance.host_vm_daily_performance_fact
	JOIN 	dwh_performance.host_dimension
	ON 	dwh_performance.host_vm_daily_performance_fact.hostTk = dwh_performance.host_dimension.tk
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.host_vm_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= 	(	SELECT 	MAX(dwh_performance.date_dimension.fullDate)
									FROM 	dwh_performance.date_dimension
									JOIN 	dwh_performance.host_vm_daily_performance_fact
									ON 	dwh_performance.date_dimension.tk = dwh_performance.host_vm_daily_performance_fact.dateTk ) - INTERVAL 7 DAY
	LEFT JOIN
		dwh_inventory.hv_server
	ON 	dwh_performance.host_dimension.id = dwh_inventory.hv_server.hostId
	GROUP BY
		dwh_performance.date_dimension.fullDate,
		dwh_inventory.hv_server.clusterName,
		dwh_performance.host_dimension.name
	) esxPerf
GROUP BY
	esxPerf.cluster
ORDER BY
	`Peak CPU Utilization` DESC
LIMIT 5</sqlText>
		<mdProjectedItems><mdProjectedItem name="Cluster"/><mdProjectedItem name="CPU Utilization - AVG"/><mdProjectedItem name="Peak CPU Utilization"/><mdProjectedItem name="Memory Utilization - AVG"/><mdProjectedItem name="Peak Memory Utilization"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Cluster"><expression>[SQL4].[Cluster]</expression></dataItem><dataItem name="Avg CPU Utilization"><expression>[SQL4].[CPU Utilization - AVG]</expression></dataItem><dataItem name="Peak CPU Utilization" aggregate="maximum"><expression>[SQL4].[Peak CPU Utilization]</expression></dataItem><dataItem name="Available" aggregate="maximum"><expression>1 - [SQL4].[Peak CPU Utilization]</expression></dataItem></selection>
		</query><query name="Top Clusters by Disk Usage">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 	IFNULL(esxPerf.cluster, 'N/A') AS 'Cluster',
	ROUND(AVG(esxPerf.cpuUsed), 2) AS 'CPU Utilization - AVG',
	MAX(esxPerf.cpuUsed) AS 'CPU Utilization - MAX',
	ROUND(AVG(esxPerf.memUsed), 2) AS 'Memory Utilization - AVG',
	MAX(esxPerf.memUsed) AS 'Peak Memory Utilization'
FROM 	(
	SELECT 	dwh_performance.date_dimension.tk dateTk,
		dwh_performance.date_dimension.fullDate fullDate,
		dwh_inventory.hv_server.clusterName cluster,
		dwh_performance.host_dimension.name esx,
		ROUND(MAX(dwh_performance.host_vm_daily_performance_fact.cpuUtilization)/100,2) cpuUsed,
		ROUND(MAX(dwh_performance.host_vm_daily_performance_fact.memoryUtilization)/100,2) memUsed
	FROM 	dwh_performance.host_vm_daily_performance_fact
	JOIN 	dwh_performance.host_dimension
	ON 	dwh_performance.host_vm_daily_performance_fact.hostTk = dwh_performance.host_dimension.tk
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.host_vm_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= 	(	SELECT 	MAX(dwh_performance.date_dimension.fullDate)
									FROM 	dwh_performance.date_dimension
									JOIN 	dwh_performance.host_vm_daily_performance_fact
									ON 	dwh_performance.date_dimension.tk = dwh_performance.host_vm_daily_performance_fact.dateTk ) - INTERVAL 7 DAY
	LEFT JOIN
		dwh_inventory.hv_server
	ON 	dwh_performance.host_dimension.id = dwh_inventory.hv_server.hostId
	GROUP BY
		dwh_performance.date_dimension.fullDate,
		dwh_inventory.hv_server.clusterName,
		dwh_performance.host_dimension.name
	) esxPerf
GROUP BY
	esxPerf.cluster
ORDER BY
	`Peak Memory Utilization` DESC
LIMIT 5</sqlText>
		<mdProjectedItems><mdProjectedItem name="Cluster"/><mdProjectedItem name="CPU Utilization - AVG"/><mdProjectedItem name="CPU Utilization - MAX"/><mdProjectedItem name="Memory Utilization - AVG"/><mdProjectedItem name="Peak Memory Utilization"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Cluster"><expression>[SQL5].[Cluster]</expression></dataItem><dataItem name="Avg Memory Utilization"><expression>[SQL5].[Memory Utilization - AVG]</expression></dataItem><dataItem name="Peak Memory Utilization" aggregate="maximum"><expression>[SQL5].[Peak Memory Utilization]</expression></dataItem><dataItem name="Available" aggregate="maximum"><expression>1 - [SQL5].[Peak Memory Utilization]</expression></dataItem></selection>
		</query><query name="Capacity and Performance by ESX">
			<source>
				
			<sqlQuery name="SQL6" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	IFNULL(cap.cluster, 'N/A') AS 'Cluster',
	cap.esx AS 'Hypervisor',
	cap.vmTk AS 'VM Count',
	cap.datastoreTB AS 'Allocated (TB)',
	cap.vmdkTB AS 'Provisioned (TB)',
	cap.usedTB AS 'Used (TB)',
	ROUND(cap.usedTB/cap.datastoreTB, 4) AS 'Used (%)',
	cap.freeTB AS 'Free (TB)',
	esxPerf.cpuCount AS 'CPU Count',
	esxPerf.memoryGB AS 'Memory (GB)',
	ROUND(AVG(esxPerf.cpuUsed), 2) AS 'Average CPU (%)',
	MAX(esxPerf.cpuUsed) AS 'Peak CPU (%)',
	ROUND(AVG(esxPerf.memUsed), 2) AS 'Average Memory (%)',
	MAX(esxPerf.memUsed) AS 'Peak Memory (%)'
FROM 	(
 	SELECT 	dwh_inventory.hv_server.clusterName AS cluster,
		dwh_capacity.host_dimension.name AS esx,
		dwh_capacity.host_dimension.tk AS hostTk,
		COUNT(DISTINCT dwh_capacity.vm_capacity_fact.vmTk) AS vmTk,
		ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB)/1024/1024, 0) AS dataStoreTB,
		ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024, 0) AS vmdkTB,
		ROUND(SUM(IF(dwh_capacity.vm_capacity_fact.capacityType = 'Datastore Unused', 0, dwh_capacity.vm_capacity_fact.actualMB))/1024/1024, 0) AS usedTB,
		ROUND(SUM(IF(dwh_capacity.vm_capacity_fact.capacityType &lt;&gt; 'Datastore Unused', 0, dwh_capacity.vm_capacity_fact.actualMB))/1024/1024, 0) AS freeTB
	FROM 	dwh_capacity.vm_capacity_fact
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	dwh_capacity.date_dimension.latest = 1
	JOIN 	dwh_capacity.host_dimension
	ON 	dwh_capacity.vm_capacity_fact.hostTk = dwh_capacity.host_dimension.tk
	JOIN
		dwh_inventory.hv_server
	ON 	dwh_capacity.host_dimension.id = dwh_inventory.hv_server.hostId
	GROUP BY
		dwh_inventory.hv_server.clusterName,
		dwh_capacity.host_dimension.name
	) cap
LEFT JOIN 
	(
	SELECT 	dwh_performance.date_dimension.tk dateTk,
		dwh_performance.date_dimension.fullDate fullDate,
		dwh_inventory.hv_server.clusterName cluster,
		dwh_performance.host_dimension.name esx,
		dwh_performance.host_dimension.tk hostTk,
		dwh_inventory.host.cpuCount cpuCount,
		ROUND(dwh_inventory.host.installedMemoryMB/1024, 0)  AS memoryGB,
		ROUND(MAX(dwh_performance.host_vm_daily_performance_fact.cpuUtilization)/100,2) cpuUsed,
		ROUND(MAX(dwh_performance.host_vm_daily_performance_fact.memoryUtilization)/100,2) memUsed
	FROM 	dwh_performance.host_vm_daily_performance_fact
	JOIN 	dwh_performance.host_dimension
	ON 	dwh_performance.host_vm_daily_performance_fact.hostTk = dwh_performance.host_dimension.tk
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.host_vm_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= 	(	SELECT 	MAX(dwh_performance.date_dimension.fullDate)
									FROM 	dwh_performance.date_dimension
									JOIN 	dwh_performance.host_vm_daily_performance_fact
									ON 	dwh_performance.date_dimension.tk = dwh_performance.host_vm_daily_performance_fact.dateTk ) - INTERVAL 7 DAY
	JOIN 	dwh_inventory.host
	ON 	dwh_performance.host_dimension.id = dwh_inventory.host.id
	JOIN 	dwh_inventory.hv_server
	ON 	dwh_performance.host_dimension.id = dwh_inventory.hv_server.hostId
	GROUP BY
		dwh_performance.date_dimension.fullDate,
		dwh_inventory.hv_server.clusterName,
		dwh_performance.host_dimension.name
	) esxPerf
ON 	cap.hostTk = esxPerf.hostTk
GROUP BY
	cap.cluster,
	cap.esx</sqlText>
		<mdProjectedItems><mdProjectedItem name="Cluster"/><mdProjectedItem name="Hypervisor"/><mdProjectedItem name="VM Count"/><mdProjectedItem name="Allocated (TB)"/><mdProjectedItem name="Provisioned (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Used (%)"/><mdProjectedItem name="Free (TB)"/><mdProjectedItem name="CPU Count"/><mdProjectedItem name="Memory (GB)"/><mdProjectedItem name="Average CPU (%)"/><mdProjectedItem name="Peak CPU (%)"/><mdProjectedItem name="Average Memory (%)"/><mdProjectedItem name="Peak Memory (%)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Cluster"><expression>[SQL6].[Cluster]</expression></dataItem><dataItem name="Hypervisor"><expression>[SQL6].[Hypervisor]</expression></dataItem><dataItem name="VM Count"><expression>[SQL6].[VM Count]</expression></dataItem><dataItem name="Allocated (TB)"><expression>[SQL6].[Allocated (TB)]</expression></dataItem><dataItem name="Provisioned (TB)"><expression>[SQL6].[Provisioned (TB)]</expression></dataItem><dataItem name="Used (TB)"><expression>[SQL6].[Used (TB)]</expression></dataItem><dataItem name="Used (%)"><expression>[SQL6].[Used (%)]</expression></dataItem><dataItem name="Free (TB)"><expression>[SQL6].[Free (TB)]</expression></dataItem><dataItem name="CPU Count"><expression>[SQL6].[CPU Count]</expression></dataItem><dataItem name="Memory (GB)"><expression>[SQL6].[Memory (GB)]</expression></dataItem><dataItem name="Average CPU (%)"><expression>[SQL6].[Average CPU (%)]</expression></dataItem><dataItem name="Peak CPU (%)"><expression>[SQL6].[Peak CPU (%)]</expression></dataItem><dataItem name="Average Memory (%)"><expression>[SQL6].[Average Memory (%)]</expression></dataItem><dataItem name="Peak Memory (%)"><expression>[SQL6].[Peak Memory (%)]</expression></dataItem></selection>
		</query><query name="Last Week's Performance Trends">
			<source>
				
			<sqlQuery name="SQL7" dataSource="dwh_performance" type="passThrough">
			<sqlText>	SELECT 	dwh_performance.date_dimension.fullDate AS 'Date',
		dwh_inventory.hv_server.clusterName AS 'Cluster',
		dwh_performance.host_dimension.name AS 'ESX',
		ROUND(MAX(dwh_performance.host_vm_daily_performance_fact.cpuUtilization)/100,2) AS 'CPU (%)',
		ROUND(MAX(dwh_performance.host_vm_daily_performance_fact.memoryUtilization)/100,2) AS 'Memory (%)'
	FROM 	dwh_performance.host_vm_daily_performance_fact
	JOIN 	dwh_performance.host_dimension
	ON 	dwh_performance.host_vm_daily_performance_fact.hostTk = dwh_performance.host_dimension.tk
	JOIN 	dwh_performance.date_dimension
	ON 	dwh_performance.host_vm_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
	AND 	dwh_performance.date_dimension.fullDate &gt;= 	(	SELECT 	MAX(dwh_performance.date_dimension.fullDate)
									FROM 	dwh_performance.date_dimension
									JOIN 	dwh_performance.host_vm_daily_performance_fact
									ON 	dwh_performance.date_dimension.tk = dwh_performance.host_vm_daily_performance_fact.dateTk ) - INTERVAL 7 DAY
	JOIN 	dwh_inventory.host
	ON 	dwh_performance.host_dimension.id = dwh_inventory.host.id
	JOIN 	dwh_inventory.hv_server
	ON 	dwh_performance.host_dimension.id = dwh_inventory.hv_server.hostId
	GROUP BY
		dwh_performance.date_dimension.fullDate,
		dwh_inventory.hv_server.clusterName,
		dwh_performance.host_dimension.name</sqlText>
		<mdProjectedItems><mdProjectedItem name="Date"/><mdProjectedItem name="Cluster"/><mdProjectedItem name="ESX"/><mdProjectedItem name="CPU (%)"/><mdProjectedItem name="Memory (%)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Date"><expression>[SQL7].[Date]</expression></dataItem><dataItem name="Cluster"><expression>[SQL7].[Cluster]</expression></dataItem><dataItem name="ESX"><expression>[SQL7].[ESX]</expression></dataItem><dataItem name="CPU (%)" aggregate="maximum"><expression>[SQL7].[CPU (%)]</expression></dataItem><dataItem name="Memory (%)" aggregate="maximum"><expression>[SQL7].[Memory (%)]</expression></dataItem></selection>
		</query></queries><classStyles><classStyle name="ls"><CSS value="border-collapse:collapse"/></classStyle><classStyle name="lt"><CSS value="border-top-style:none;border-right-style:none;border-left-style:none;background-color:white;color:black;text-align:left;font-weight:bold;background-image:none;border-bottom:1.5pt solid black"/></classStyle><classStyle name="lc"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lm"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black;background-image:none"/></classStyle><classStyle name="lh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lf"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="ih"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black;background-image:none"/></classStyle><classStyle name="if"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black;background-image:none"/></classStyle><classStyle name="is"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black;background-image:none"/></classStyle><classStyle name="oh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="of"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black;background-image:none"/></classStyle><classStyle name="os"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black;background-image:none"/></classStyle></classStyles><reportName>CM2</reportName><namedConditionalStyles><advancedConditionalStyle name="Conditional Style 1"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[ESX Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[ESX Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 2"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[VM Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[VM Change] &gt;0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 3"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Datastore Allocated Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Datastore Allocated Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 4"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[VMDK Allocated Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[VMDK Allocated Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 5"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Used Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Used Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 6"><styleCases><styleCase><style><CSS value="color:#CF2128"/></style><reportCondition>[Capacity Changes].[Free Change] &lt; 0</reportCondition></styleCase><styleCase><style><CSS value="color:#77BF72"/></style><reportCondition>[Capacity Changes].[Free Change] &gt; 0</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="color:#808080"/></style></styleDefault></advancedConditionalStyle></namedConditionalStyles></report>